﻿CREATE TABLE [dbo].[Customer_Update_Log] (
    [Id]                INT              IDENTITY (1, 1) NOT NULL,
    [CustomerId]        UNIQUEIDENTIFIER NULL,
    [CustomerName_Old]  VARCHAR (200)    NULL,
    [CustomerName_New]  VARCHAR (200)    NULL,
    [MnemonicWorks_Old] VARCHAR (50)     NULL,
    [MnemonicWorks_New] VARCHAR (50)     NULL,
    [Pid_Old]           INT              NULL,
    [Pid_New]           INT              NULL,
    [Cid_Old]           INT              NULL,
    [Cid_New]           INT              NULL,
    [Rid_Old]           INT              NULL,
    [Rid_New]           INT              NULL,
    [Address_Old]       VARCHAR (200)    NULL,
    [Address_New]       VARCHAR (200)    NULL,
    [SourceId_Old]      INT              NULL,
    [SourceId_New]      INT              NULL,
    [StateId_Old]       INT              NULL,
    [StateId_New]       INT              NULL,
    [TypeId_Old]        INT              NULL,
    [TypeId_New]        INT              NULL,
    [IndustryOneId_Old] INT              NULL,
    [IndustryOneId_New] INT              NULL,
    [IndustryTwoId_Old] INT              NULL,
    [IndustryTwoId_new] INT              NULL,
    [Zip_Old]           VARCHAR (50)     NULL,
    [Zip_New]           VARCHAR (50)     NULL,
    [WebAddress_Old]    VARCHAR (50)     NULL,
    [WebAddress_New]    VARCHAR (50)     NULL,
    [Fax_Old]           VARCHAR (50)     NULL,
    [Fax_New]           VARCHAR (50)     NULL,
    [UpdateTime]        DATETIME         DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_CUSTOMER_UPDATE_LOG] PRIMARY KEY CLUSTERED ([Id] ASC)
);

